<%@ include file="IsProff.jsp"%>
<%@ page import="java.sql.*"%>
<%
	String prjid = request.getParameter("prjid");
	String stdid = request.getParameter("stdid");

	String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
	try
	{
		Class.forName(driver);
		Connection connection = DriverManager.getConnection(
				"jdbc:odbc:SPMS", "", "");
		Statement statement = connection.createStatement();
		String query = "UPDATE project set studentid = "+stdid+" where id = "+prjid;
		statement.executeUpdate(query);
	} catch (ClassNotFoundException cnfe)
	{
		out.println("No such class: " + driver);
	}
%>
